---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/jesse/Dropbox/Ohio-HallResearch/Code/replication/table_a6.log
  log type:  text
 opened on:  11 Jun 2020, 12:48:37

. 
. // All Counties
. 
. use "$path/us_county_dataset.dta", clear

. 
. collapse (first) totpop_acs-hispanic, by(fips county state)

. gen age_18_29 = age_18_24 + age_25_29
(55 missing values generated)

. gen age_30_44 = age_30_34 + age_35_39 + age_40_44
(55 missing values generated)

. gen age_45_64 = age_45_49 + age_50_54 + age_55_59 + age_60_64
(55 missing values generated)

. gen age_65_up = age_65_69 + age_7074 + age_75_79 + age_80_84 + age_85_up
(55 missing values generated)

. gen educ_no_hs_deg = educ_nohs + educ_somehs
(55 missing values generated)

. gen educ_hs_deg = educ_hs
(55 missing values generated)

. gen educ_some_coll = educ_somecoll + educ_assoc
(55 missing values generated)

. order educ_ba, after(educ_some_coll)

. gen educ_post_grad = educ_post
(55 missing values generated)

. 
. drop age_18_24-educ_post

. drop natam other_race two_race

. 
. mean totpop_acs

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
  totpop_acs |   100099.1   5717.883      88887.89    111310.2
--------------------------------------------------------------

. mat a = e(b)

. local totpop_1 = a[1,1]

. foreach var of varlist female-educ_post_grad {
  2. mean `var' [aweight = totpop_acs]
  3. mat b = e(b)
  4. local `var'_1 = b[1,1]
  5. }

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
      female |   .5080785   .0002266      .5076342    .5085228
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
unemployment |   .0929206   .0004669      .0920053     .093836
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

---------------------------------------------------------------
              |       Mean   Std. Err.     [95% Conf. Interval]
--------------+------------------------------------------------
house_med_inc |   55793.23   265.0887      55273.46    56312.99
---------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
house_mean_inc |   74894.69   348.8236      74210.74    75578.63
----------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
       white |   .6277845   .0039232      .6200922    .6354769
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
       black |   .1222936   .0022597       .117863    .1267242
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
       asian |   .0494754   .0010721      .0473734    .0515775
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
    hispanic |   .1690132   .0029868      .1631568    .1748695
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_18_29 |   .1678324   .0006503      .1665575    .1691074
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_30_44 |   .1960406    .000397      .1952621     .196819
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_45_64 |   .2637367   .0004735      .2628083    .2646652
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_65_up |   .1374629   .0006462      .1361959    .1387299
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
educ_no_hs_deg |    .137616   .0010392      .1355784    .1396536
----------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
 educ_hs_deg |   .2786128   .0012814      .2761004    .2811252
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
educ_some_coll |   .2912942   .0008438      .2896397    .2929488
----------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
     educ_ba |   .1825471   .0010513      .1804858    .1846084
--------------------------------------------------------------

Mean estimation                   Number of obs   =      3,136

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
educ_post_grad |   .1098385   .0009088      .1080567    .1116204
----------------------------------------------------------------

. local N_1 = e(N)

. 
. // CoreLogic Counties
. 
. use "$path/us_county_dataset.dta", clear

. keep if total_records != .
(85,345 observations deleted)

. 
. collapse (first) totpop_acs-hispanic, by(fips county state)

. gen age_18_29 = age_18_24 + age_25_29
(1 missing value generated)

. gen age_30_44 = age_30_34 + age_35_39 + age_40_44
(1 missing value generated)

. gen age_45_64 = age_45_49 + age_50_54 + age_55_59 + age_60_64
(1 missing value generated)

. gen age_65_up = age_65_69 + age_7074 + age_75_79 + age_80_84 + age_85_up
(1 missing value generated)

. gen educ_no_hs_deg = educ_nohs + educ_somehs
(1 missing value generated)

. gen educ_hs_deg = educ_hs
(1 missing value generated)

. gen educ_some_coll = educ_somecoll + educ_assoc
(1 missing value generated)

. order educ_ba, after(educ_some_coll)

. gen educ_post_grad = educ_post
(1 missing value generated)

. 
. drop age_18_24-educ_post

. drop natam other_race two_race

. 
. mean totpop_acs

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
  totpop_acs |   108391.3    6269.02      96098.99    120683.5
--------------------------------------------------------------

. mat a = e(b)

. local totpop_2 = a[1,1]

. foreach var of varlist female-educ_post_grad {
  2. mean `var' [aweight = totpop_acs]
  3. mat b = e(b)
  4. local `var'_2 = b[1,1]
  5. }

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
      female |   .5081798   .0002344      .5077201    .5086395
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
unemployment |   .0928985   .0004825      .0919524    .0938446
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

---------------------------------------------------------------
              |       Mean   Std. Err.     [95% Conf. Interval]
--------------+------------------------------------------------
house_med_inc |   55984.77   277.3704       55440.9    56528.64
---------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
house_mean_inc |   75184.02   364.9783      74468.37    75899.67
----------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
       white |   .6255015   .0040991       .617464     .633539
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
       black |   .1226307   .0023549      .1180131    .1272482
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
       asian |   .0501128   .0011286      .0478999    .0523257
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
    hispanic |   .1709268   .0031405      .1647689    .1770847
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_18_29 |   .1679085   .0006696      .1665954    .1692215
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_30_44 |   .1963426   .0004139      .1955311    .1971541
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_45_64 |    .263624   .0004935      .2626563    .2645917
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
   age_65_up |   .1371376   .0006732      .1358176    .1384576
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
educ_no_hs_deg |   .1373785   .0010878      .1352455    .1395115
----------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
 educ_hs_deg |   .2773055   .0013316      .2746945    .2799164
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
educ_some_coll |    .291207   .0008853       .289471    .2929429
----------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

--------------------------------------------------------------
             |       Mean   Std. Err.     [95% Conf. Interval]
-------------+------------------------------------------------
     educ_ba |   .1835156   .0010961      .1813664    .1856647
--------------------------------------------------------------

Mean estimation                   Number of obs   =      2,850

----------------------------------------------------------------
               |       Mean   Std. Err.     [95% Conf. Interval]
---------------+------------------------------------------------
educ_post_grad |   .1105019   .0009511      .1086371    .1123667
----------------------------------------------------------------

. local N_2 = e(N)

. 
. log close
      name:  <unnamed>
       log:  /Users/jesse/Dropbox/Ohio-HallResearch/Code/replication/table_a6.log
  log type:  text
 closed on:  11 Jun 2020, 12:48:41
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
